-----------------------------Tai khoan the--------------------

if exists (select name from sysobjects where name like 'Proc_TaiKhoanThe_UpdateSodu')
	drop procedure Proc_TaiKhoanThe_UpdateSodu
go

create PROC Proc_TaiKhoanThe_UpdateSodu (@maTKThe int,@soDu float)
as
set tran isolation level read committed
begin tran

		Update TaiKhoanThe 
		set SoDu= @soDu
		where MaTaiKhoanThe= @maTKThe 
rollback
go

------------------

if exists (select name from sysobjects where name like 'Proc_TaiKhoanThe_XemSodu')
	drop procedure Proc_TaiKhoanThe_XemSodu
go

create PROC Proc_TaiKhoanThe_XemSodu (@maTKThe int)
as
set tran isolation level read committed
begin tran
		select * from TaiKhoanThe
		where MaTaiKhoanThe= @maTKThe 
commit tran
go